<?php require_once('connections/con_gl.php'); require_once("excel/excelwriter.class.php");?>
<?php
cekAkses($_SESSION[akses],"KB-3");
$currentPage = $_SERVER["PHP_SELF"];

$maxRows_data = 8;
$pageNum_data = 0;
if (isset($_GET['pageNum_data'])) {
  $pageNum_data = $_GET['pageNum_data'];
}
$startRow_data = $pageNum_data * $maxRows_data;
$cr_txt = str_replace("+"," ",$_REQUEST[cr_txt]);
mysql_select_db($database_con_gl, $con_gl);
$query_data = "SELECT gl_trans.akun, gl_trans.no_ref, gl_rtrans.tgl, gl_trans.transaksi, gl_trans.total, gl_rtrans.kontak, gl_kontak.nama, gl_trans.id, gl_rtrans.keterangan FROM gl_trans, gl_rtrans, gl_kontak WHERE gl_rtrans.jenis=4 AND gl_rtrans.no_ref = gl_trans.no_ref AND gl_kontak.id = gl_rtrans.kontak AND (gl_trans.pos='K' XOR gl_trans.x_ref is NULL)";
if(!strstr($_SESSION[akses],'A-1-4')) {
	$query_data .= " AND gl_rtrans.gudang='$_SESSION[lokasi]'";
}
if($_GET[cr_txt]<>'' AND $_GET[cr_txt]<>'+') { 
$decode_cr = str_replace("+"," ",$_GET[cr_txt]);
$query_data .=" AND (gl_rtrans.no_ref LIKE '%%$decode_cr%%' OR gl_rtrans.tgl LIKE '%%$decode_cr%%' OR gl_rtrans.keterangan LIKE '%%$decode_cr%%')";
}
if($_GET[mulai]<>'' AND $_GET[sampai]<>'') { 
$query_data .=" AND gl_rtrans.tgl between '$_GET[mulai]' AND '$_GET[sampai]'";
}
$query_data .=" GROUP BY gl_rtrans.no_ref desc";
$query_limit_data = sprintf("%s LIMIT %d, %d", $query_data, $startRow_data, $maxRows_data);
$data = mysql_query($query_limit_data, $con_gl) or die(mysql_error());
$row_data = mysql_fetch_assoc($data);

if (isset($_GET['totalRows_data'])) {
  $totalRows_data = $_GET['totalRows_data'];
} else {
  $all_data = mysql_query($query_data);
  $totalRows_data = mysql_num_rows($all_data);
}
$totalPages_data = ceil($totalRows_data/$maxRows_data)-1;

$queryString_data = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_data") == false && 
        stristr($param, "totalRows_data") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_data = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_data = sprintf("&totalRows_data=%d%s", $totalRows_data, $queryString_data);

// Export Excel
$excel=new ExcelWriter("report_kaskeluar.xls");
if($excel==false)	
echo $excel->error;

$myArr=array("Tanggal","No Referensi","Ke","Total","Keterangan");
$excel->writeLine($myArr);

$qry=mysql_query($query_data, $con_gl);
if($qry!=false)
{
	$i=1;
	while($res=mysql_fetch_array($qry))
	{
		$total = mysql_query("select total from gl_trans where no_ref='$res[no_ref]' AND pos='K'",$con_gl);
		$row_total = mysql_fetch_assoc($total);
		$myArr=array($res['tgl'],$res['no_ref'],$res['nama'],$row_total['total'],$res['keterangan']);
		$excel->writeLine($myArr);
		$i++;
	}
}
// End Export
include('include/widget_exportall.php');
?>
<link href="css/ui.datepicker.css" type="text/css" rel="stylesheet" />
<script language="javascript">
function download()
{
	window.location='report_kaskeluar.xls';
}
</script>
<script type="text/javascript" src="js/ui.datepicker.js"></script>
<script type="text/javascript">
<!--
$(function()
      {
        $('.calendar').datepicker({
            appendText : "",
            dateFormat : 'yy/mm/dd'
          });
      });
</script>
<h1>Kas Keluar </h1> 
<table width="100%" border="0" align="center" cellpadding="5" cellspacing="0" class="datatable"> 
  <tr class="hide">
    <td><?php if(strstr($_SESSION[akses],"KB-3-1")) { ?><a href="index.php?component=kaskeluar&amp;task=add"><img src="images/add_new.png" border="0" /></a><?php } ?></td>
    <td>&nbsp;</td>
    <td colspan="4" align="right">
	  <form id="search" name="search" method="post" action="" class="tanggalsearch">
	    <label>
      Tanggal : <input name="mulai" type="text" id="mulai" value="<?php echo $_GET[mulai];?>" size="15" maxlength="15" class="calendar"/></label> s/d <label><input name="sampai" type="text" id="sampai" value="<?php echo $_GET[sampai];?>" size="15" maxlength="15" class="calendar"/>
        </label>
        <label>
      Kata Kunci : <input name="cr_txt" type="text" id="cr_txt" value="<?php echo $_REQUEST['cr_txt'];?>" size="30" maxlength="100"/>
        </label>
		<label>
      <input name="Search" type="submit" id="Search" value="Search" />
        </label>
	  </form>
	<?php
	if(isset($_POST['Search'])) {
		echo "<script>window.location=\"index.php?component=kaskeluar&mulai=".$_POST[mulai]."&sampai=".$_POST[sampai]."&cr_txt=".str_replace(" ","+",$_POST[cr_txt])."\";</script>";
	}
	?></td>
  </tr>
  <tr>
    <th width="10%" align="center"><strong>Tanggal</strong></th>
    <th width="18%" align="center"><strong>No Referensi</strong></th>
    <th width="25%"><strong>Ke</strong></th>
    <th width="12%" align="center"><strong>Total</strong></th>
    <th><strong>Keterangan</strong></th>
    <th width="125" align="center" class="hide"><strong>Aksi</strong></th>
  </tr>
  <?php if($totalRows_data > 0) { ?>
  <?php do { ?>
  <?php
  mysql_select_db($database_con_gl, $con_gl);
$query_dari = "SELECT  nama from gl_kontak where id='$row_data[kontak]'";
$dari = mysql_query($query_dari, $con_gl) or die(mysql_error());
$row_dari = mysql_fetch_assoc($dari);
$totalRows_dari = mysql_num_rows($dari);

$queryget_total = "select total from gl_trans where no_ref='$row_data[no_ref]' AND pos='K'";
$get_total = mysql_query($queryget_total, $con_gl) or die (mysql_error());
$rowget_total = mysql_fetch_assoc($get_total);
  ?>
    <tr valign="top" bgcolor="#FFFFFF">
      <td align="center" ><?php tanggal($row_data['tgl'],"tampilkan");?></td>
      <td align="center"><a href="include/jurnalvoucher.php?referensi=<?php echo $row_data['no_ref'];?>" onclick="NewWindow(this.href,'name','940','300','yes');return false" title="Jurnal Voucher"><?php echo $row_data['no_ref']; ?></a></td>
      <td><?php echo $row_dari['nama']; ?></td>
      <td align="right"><?php echo number_format($rowget_total['total'],0,',','.').",-"; ?></td>
      <td><?php echo $row_data['keterangan']; ?></td>
      <td align="center" bgcolor="#FFFFFF" class="hide"><?php if(strstr($_SESSION[akses],"KB-3-2")) { ?><a href="index.php?component=kaskeluar&task=edit&noreferensi=<?php echo $row_data[no_ref];?>"><img src="images/edit_.png" border="0" /></a><?php } ?> <?php if(strstr($_SESSION[akses],"KB-3-3")) { ?><a href="index.php?component=kaskeluar&amp;task=delete&amp;noreferensi=<?php echo $row_data[no_ref];?>" class="ask"><img src="images/delete_.png" border="0" /></a><?php } ?></td>
    </tr>
    <?php } while ($row_data = mysql_fetch_assoc($data)); ?>
	<?php if($totalRows > $maxRows_data) { ?>
    <tr class="hide">
      <td colspan="6"><table border="0" align="left">
          <tr>
            <td width="23%" align="center"><?php if ($pageNum_data > 0) { // Show if not first page ?>
                <a href="<?php printf("%s?pageNum_data=%d%s", $currentPage, 0, $queryString_data); ?>"><img src="First.gif" border=0></a>
                <?php } // Show if not first page ?>            </td>
            <td width="31%" align="center"><?php if ($pageNum_data > 0) { // Show if not first page ?>
                <a href="<?php printf("%s?pageNum_data=%d%s", $currentPage, max(0, $pageNum_data - 1), $queryString_data); ?>"><img src="Previous.gif" border=0></a>
                <?php } // Show if not first page ?>            </td>
            <td width="23%" align="center"><?php if ($pageNum_data < $totalPages_data) { // Show if not last page ?>
                <a href="<?php printf("%s?pageNum_data=%d%s", $currentPage, min($totalPages_data, $pageNum_data + 1), $queryString_data); ?>"><img src="Next.gif" border=0></a>
                <?php } // Show if not last page ?>            </td>
            <td width="23%" align="center"><?php if ($pageNum_data < $totalPages_data) { // Show if not last page ?>
                <a href="<?php printf("%s?pageNum_data=%d%s", $currentPage, $totalPages_data, $queryString_data); ?>"><img src="Last.gif" border=0></a>
                <?php } // Show if not last page ?>            </td>
          </tr>
        </table></td>
    </tr>
	<?php } ?>
   <?php }else{ ?>
  <tr bgcolor="#FFFFFF">
    <td colspan="6">Data tidak ada !!! </td>
  </tr>
  <?php } ?>
  <tr class="hide">
    <td colspan="6"><?php if(strstr($_SESSION[akses],"KB-3-1")) { ?><a href="index.php?component=kaskeluar&amp;task=add"><img src="images/add_new.png" border="0" /></a><?php } ?>
    </td>
  </tr>
</table>
